All Questions
Tagged with database-internalsinnodb
6 questions
2votes
1answer
84views
Why does innodb next-key locks lock more range than the condition?
Assume the following table: DROP TABLE IF EXISTS person; CREATE TABLE person ( id int unsigned auto_increment primary key, name varchar(255) not null, age tinyint unsigned, key (age)...
- 155
3votes
0answers
81views
Are Innodb redo logs written atomically?
When flushing dirty pages from buffer pool to disk pages, it uses double write buffering to avoid half written pages. But redo logs do not have such mechanism. So, how does it prevent redo logs from ...
- 155
2votes
2answers
1kviews
When does MySQL begin to start sending data to a client?
I am working on MySQL 5.7 with the default configuration of InnoDB storage engine. I have two questions each for a different scenario and need to know the internal working on how MySQL sends data to ...
- 155
1vote
1answer
539views
How are page splits determined internally in MySQL?
Going through this answer for a stack-overflow question, I found a fact that In The physical structure of InnoDB index pages I describe the Last Insert Position, Page Direction, and Number of ...
- 664
9votes
2answers
5kviews
In what cases are BLOB and TEXT stored in-line on InnoDB?
I've googled this and can't find it, you can see Rick James mention it here. ... BLOB and TEXT are not always stored separately The answer on What is the difference between MySQL VARCHAR and TEXT ...
- 65.2k
2votes
1answer
191views
If a query reads more pages than the InnoDB buffer can hold, are all the previous pages evicted?
If I have some (hot) pages in the InnoDB buffer, and I perform a query which reads an amount of data larger than the buffer itself, will the hot pages be necessarily evicted?
- 390
